SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwrMeses
AS
SELECT     idMes AS ID, REPLICATE('0', 2 - LEN(RTRIM(CONVERT(VARCHAR(2), idMes)))) + RTRIM(CONVERT(VARCHAR(2), idMes)) 
                      + ' - ' + Nombre AS Descripcion
FROM         dbo.tb_Meses
GO
GRANT SELECT ON  [dbo].[vwrMeses] TO [CertificacionesServicios]
GRANT SELECT ON  [dbo].[vwrMeses] TO [Liquidaciones]
GRANT SELECT ON  [dbo].[vwrMeses] TO [public]
GRANT SELECT ON  [dbo].[vwrMeses] TO [SoloVer]
GRANT SELECT ON  [dbo].[vwrMeses] TO [Subsidios]
GO
